[dbo].[BAEOrderAnswerUpdate]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAEOrderAnswerUpdate
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@OrderNumber
float
8
@OldOrderNumber
float
8
@QuestionID
int
4
@OldQuestionID
int
4
@Answer
varchar(512)
512
SQL Script
create
procedure
[dbo]
.
[BAEOrderAnswerUpdate]
@OrderNumber
as
float
,
@OldOrderNumber
AS
float
,
@QuestionID
AS
int
,
@OldQuestionID
AS
int
,
@Answer
AS
varchar
(
512
)
AS
UPDATE
OrderAnswer
SET
OrderNumber
=
@OrderNumber
,
QuestionID
=
@QuestionID
,
Answer
=
@Answer
WHERE
OrderNumber
=
@OldOrderNumber
AND
QuestionID
=
@OldQuestionID
;
GO
Uses
[dbo].[OrderAnswer]
dbo